| FaMultiDisbSchedRule |
| Logical Entity Name | FaMultiDisbSchedRule |
| Default Table Name | FaMultiDisbSchedRule |
| Physical Only | NO |
| Definition | |
| Note |
| FaMultiDisbSchedRule Columns |
| ColumnName | Domain | Datatype | NULL | Definition |
FaMultiDisbSchedRuleID |
int | NO | ||
FaMultiDisbSchedRuleCriteriaID |
int | NO | ||
| PaymentPeriodNum | int | NO | ||
| DisbNum | int | NO | ||
| RuleName | char(16) | NO | ||
| ParamX | int | NO | ||
| ParamY | int | YES | ||
| RuleNameDefault | char(16) | YES | ||
| ParamXDefault | int | YES | ||
| ParamYDefault | int | YES | ||
| FTB_ParamX | int | YES | ||
| FTB_ParamY | int | YES | ||
| IsStandardPP | bit | NO | ||
UserID |
int | NO | ||
| DateAdded | datetime | NO | ||
| DateLstMod | datetime | NO | ||
| ts | timestamp | NO |
| FaMultiDisbSchedRule Primary and Unique Keys |
| Key Name | Key Type | Keys |
| Pk_FaMultiDisbSchedRule_FaMultiDisbSchedRuleId | PrimaryKey | FaMultiDisbSchedRuleID |
| FaMultiDisbSchedRule Foreign Keys |
| Parent Relationships: |
| Table Name | Type | Cardinality | Constraint Name | VerbPhrase | InversePhrase | Foreign Keys | Is Supertype | Not For Replication |
| FaMultiDisbSchedRuleCriteria | Non-Identifying | One To Zero or More | FK_FaMultiDisbSchedRule_FaMultiDisbSchedRuleCriteriaID_FaMultiDisbSchedRuleCriteria | FaMultiDisbSchedRuleCriteriaID | NO | YES | ||
| SyStaff | Non-Identifying | One To Zero or More | FK_FaMultiDisbSchedRule_UserId_SyStaff | UserID | NO | YES |
| Child Relationships: |
| Table Name | Type | Cardinality | Constraint Name | VerbPhrase | InversePhrase | Foreign Keys | Is Subtype | Not For Replication |
| FaMultiDisbSchedRule Check Constraints |
| Check Constraint Name | CheckConstraint |